-- created by kumiler
-- on 2022/12/28 13:59
-- DESC

create external table jms_ods.tab_dw_market_signtimely
(
    id string comment '主键id',
    project_name string comment '项目名称',
    origin_provice_id string comment '始发省份id',
    origin_provice_name string comment '始发省份名称',
    origin_city_id string comment '始发城市id',
    origin_city_name string comment '始发城市名称',
    purpose_province_id string comment '目的省份id',
    purpose_province_name string comment '目的省份名称',
    purpose_city_id string comment '目的城市id',
    purpose_city_name string comment '目的城市名称',
    region_type string comment '区域类型',
    timely_type string comment '时效类型',
    city_timely1 string comment '城市时效1',
    city_t_timely string comment '城市T+时效',
    line string comment '线路',
    create_by string comment '创建人',
    update_by string comment '修改人',
    create_time string comment '创建时间',
    update_time string comment '修改时间'
) comment '数据驾舱-市场-签收时效配置表'
 partitioned by (dt string comment '分区字段-同步日期')
stored as parquet
LOCATION '/dw/hive/jms_ods.db/external/tab_dw_market_signtimely'
;